﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_FIT_TRAINING_TYPE_Get_Training_type')
	BEGIN
		DROP Procedure usp_UPDMS_FIT_TRAINING_TYPE_Get_Training_type
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_FIT_TRAINING_TYPE_Get_Training_type
**	Desc : 운동종류를 조회한다.
**	Test Exec Query : Exec usp_UPDMS_FIT_TRAINING_TYPE_Get_Training_type
**	Called by : Fit_Dac_UPDMS_FIT_TRAINING_TYPE.cs
**	Program ID : Fit1011m
**	Auth : 송시명
**	Date : 2014-05-21
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_FIT_TRAINING_TYPE_Get_Training_type]
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON

SELECT Training_Type_Id,
       Training_Nm
  FROM UPDMS_FIT_TRAINING_TYPE WITH(NOLOCK)
 WHERE Use_Yn = 'Y'
 ORDER BY Training_Part, View_Order

GO